ICDMerchandiseTaxLineItem

Entity Definition

Logical Name : ICDMerchandiseTaxLineItem
Physical Name : DO_LTM_ICD_MR_TX

A Line Item to record taxation implications of a single ICDMerchandiseLineItem rather than an entire InventoryControlDocument.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
TaxGroupRuleID (FK)(PK) System assigned unique identifier for the TaxGroupRule. ID_RU_TX_GRP Identity integer TaxGroupRule(RU_TX_GP)
InventoryControlDocumentID (FK)(PK) The reference number that uniquely identifies the InventoryControlDocument. ID_ICD Identity integer ICDMerchandiseLineItem(DO_LTM_ICD_MR)
InventoryControlDocumentLineItemID (FK)(PK) A unique system assigned identifier for the LineItem within the confines of the InventoryControlDocument. IC_LTM_ICD LineNumber smallint ICDMerchandiseLineItem(DO_LTM_ICD_MR)
ICDChargeAllowanceProcessingRuleID (FK) A unique system assigned identifier for the rule denoting how a particular Charge or Allowance in an InventoryControlDocument is to be treated in the financial reporting systems. ID_ICD_CHG_ALW_RU Identity integer ICDChargeAllowanceProcessingRule(RU_ICD_CHG_ALW)
TaxableAmount The monetary value for which tax must be paid for the INVENTORY CONTROL DOCUMENT MERCHANDISE LINE ITEM MO_TXBL MoneyShortRetail decimal(7,2)
TaxAmount The amount of tax to be paid for the INVENTORY CONTROL DOCUMENT MERCHANDISE LINE ITEM MO_TX MoneyShortRetail decimal(7,2)
TaxExemptAmount The amount of tax that does not have to be paid for the INVENTORY CONTROL DOCUMENT MERCHANDISE LINE ITEM MO_TX_EXM MoneyShortRetail decimal(7,2)
TaxExemptionReasonCode A code denoting the reason why the tax that should've been paid was exempt for the INVENTORY CONTROL DOCUMENT MERCHANDISE LINE ITEM RC_TX_EXM Code2 char(2)

Relationships

Parent Entity Verb Phrase Child Entity
ICDChargeAllowanceProcessingRule defines processing for ICDMerchandiseTaxLineItem
ICDMerchandiseLineItem is charged with ICDMerchandiseTaxLineItem
TaxGroupRule defines taxability of ICDMerchandiseTaxLineItem
ICDMerchandiseTaxLineItem is exempted by ICDMerchandiseTaxExemptionLineItem

Logical Views containing ICDMerchandiseTaxLineItem

Logical View
Logical 02100 - Item Inventory - Macro View
Logical 02120 - Item Inventory - Order View
Logical 02130 - Item Inventory - Receiving View
Logical 04300 - Financial Ledger - Inventory Control View
Logical 05000 - Taxation - Macro View
Logical 05300 - Taxation - Inventory Control Document View